package com.maycurobj.repository.oa;

import com.maycurobj.entity.oa.OASecurityLevel;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface OASecurityLevelRepository extends JpaRepository<OASecurityLevel,String> {
    @Query(nativeQuery = true,value = "SELECT DISTINCT seclevel from hrmresource where workcode=:empNo and STATUS in (0,1)")
    Integer getSeclevel(@Param(value = "empNo") String empNo);
}
